Blue Prism 6.4.2: February 2019

When upgrading or creating a database, the Allow Snapshot Isolation setting is now automatically applied. This optimizes performance when sorting and filtering sessions in Control Room by preventing locks on the session table.

If snapshot isolation is not applied because the user context performing an upgrade does not have the required permissions to apply the setting, the upgrade will still be performed but users will be advised that it is not possible to log in or start Blue Prism server services without this setting being enabled.

For more information and details about how to manually enable snapshot isolation, see the upgrade notices for 6.4.2.

A number of changes have been made to improve performance in Control Room:

• The background functionality used to sort data in the Session Management screen has been removed from the user interface to improve response times. As data is sorted in the database, this functionality is no longer required.
• A number of session management queries are now configured to use snapshot isolation, further improving performance when sorting and filtering sessions.
• Data to be displayed within a session view filter is only retrieved upon selection of the filter, as opposed to being retrieved for all filters on load of control room, improving load time.
• An issue that prevented the correct data from being displayed when a saved session filter was selected has been addressed so that data appropriate to the selected filter is now displayed.
• A change has been implemented that prevents timeouts occurring when sorting high volumes of data in the Session Management screen.
• Access times for the Session Management screen have been improved by applying a default value of 500 to the session rows filter.
• When starting, creating, and deleting sessions, the number of calls to the database has been optimized to improve performance when executing these actions.